|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |

Desmont McCallock
387
|
Posted - 2014.07.26 15:50:00 -
[1] - Quote
Does anyone have any idea why those (30187, 30558,30562, 30582, 30586, 30588, 30599, 30600, 30605, 30614, 30615, 30618, 30628, 30632, 30633, 30752, 30753, 30754) are inside the blueprints.yaml file? They aren't even blueprints but items that can be reverse engineered and in the yaml file they only have the reverse engineering activity. Any reasonable explanation is much appreciated. |

Desmont McCallock
387
|
Posted - 2014.07.26 16:25:00 -
[2] - Quote
Well I guess that I have to include them in the invBlueprints table, although technically they aren't blueprints and I will have to introduce another column called reverseEngeneeringTime as they have a time factor for that activity.
No one said that this would be easy, importing the yaml files back to a DB, that is. |

Desmont McCallock
387
|
Posted - 2014.07.27 15:25:00 -
[3] - Quote
Beta release of the EVEMonSDEExternalsToSql tool for Crius. You will find it here. |

Desmont McCallock
388
|
Posted - 2014.08.02 21:28:00 -
[4] - Quote
Acid Kanshi wrote:Any CCP person can check this out? Scourge Fury Heavy Missile manufacturing http://i.imgur.com/HsNnJNZ.pngBut in SDE there are materials Tritanium, Zydrine etc. Outdated materials. Has been fixed in Crius 1.6 SDE. Looks like it's time to work on updating EVEMon's data.
|

Desmont McCallock
388
|
Posted - 2014.08.03 09:36:00 -
[5] - Quote
Just a heads up, MarketGroupID: 1912 (* Outpost Platform Blueprint) and MarketGroupID: 1913 (Station * Blueprint) are missing from the invMarketGroups table. |

Desmont McCallock
388
|
Posted - 2014.08.03 11:17:00 -
[6] - Quote
Timcanpy Yvormes wrote:Can some one help me
in the database if i do this -- Base materials SELECT t.typeName, m.quantity FROM invTypeMaterials AS m INNER JOIN invTypes AS t ON m.materialTypeID = t.typeID WHERE m.typeID = 11400--jaguar
I'm asking because i was trying to build my sheet using the conversion that Steve made to xls and the materials are also there, so i went to the DB and checked
I get materials as tritanium and others But if use Steve Ronuken site i dont see this materials I'm i doing something wrong? because i think that now most of the T2 dont have any tritanium and other low minerals.
Regards Tim If I'm not mistaken InvTypeMaterials table is now referring to what the item reprocess to. If you are looking for the manufacturing materials you need to look at Steve's industryActivityMaterials table. Further more if you are using MSSQL DB you can use my YAML/SqLite files importer for your sanity. |

Desmont McCallock
389
|
Posted - 2014.08.09 17:33:00 -
[7] - Quote
Guys, let's face it, the entire SDE will be moved to YAML files. It was announces (for CCP standards) ages ago. |

Desmont McCallock
408
|
Posted - 2014.08.21 09:49:54 -
[8] - Quote
Zifrian wrote:Desmont McCallock wrote:Guys, let's face it, the entire SDE will be moved to YAML files. It was announces (for CCP standards) ages ago. But when they changes all the universe data, they put it out as an SQLite file...not to mention that post about yaml was several years ago and we've seen little in the movement to it until Cirus. I think expecting whatever hodgepodge system they want to use that day will be what we get. 3rd party dev support is a collateral anyway, we can't expect much when it's not their primary goal. We just have to be flexible. Universe data where a little massive to extract to a YAML file and that's why they chose Sqllite. From my point of view they should had gone with Sqlite for the entire SDE, as it's another DB format anyway which wouldn't be much of a hassle to adjust our tools and apps to it.
|

Desmont McCallock
408
|
Posted - 2014.08.26 14:27:38 -
[9] - Quote
Hyperion 1.0 SDE is out. Let the conversions begin! |

Desmont McCallock
408
|
Posted - 2014.08.26 15:28:35 -
[10] - Quote
Just a heads up. There are new categories added in dgmAttributeCategories. |
|

Desmont McCallock
397
|
Posted - 2014.08.26 17:04:00 -
[11] - Quote
Well in that case, some attributes changed category ID cause it broke EVEMon data files generator. |

Desmont McCallock
408
|
Posted - 2014.08.26 17:04:13 -
[12] - Quote
Well in that case, some attributes changed category ID cause it broke EVEMon data files generator.
Edit: Yeap, they moved some attributes to category 17 (Speed). |
|
|
|